ALTER AGGREGATE 中文man页面 |
您所在的位置:网站首页 › aggregate 中文 › ALTER AGGREGATE 中文man页面 |
NAME
ALTER AGGREGATE - 修改一个聚集函数的定义 SYNOPSIS ALTER AGGREGATE name ( type ) RENAME TO newname DESCRIPTION 描述ALTER AGGREGATE 改变一个聚集函数的定义。目前唯一可用的功能是对聚集函数进行重命名。 PARAMETERS 参数 name 一个现有的聚集函数的名字(可以有模式修饰)。 type 聚集函数的参数数据类型,如果函数接受任何数据类型,则是 *。 newname 聚集函数的新名字。 EXAMPLES 例子给一个接受 integer 类型参数的叫 myavg 的聚集函数重命名为 my_average: ALTER AGGREGATE myavg(integer) RENAME TO my_average; COMPATIBILITY 兼容性SQL 标准里面没有 ALTER AGGREGATE 语句。 SEE ALSO 参见CREATE AGGREGATE [create_aggregate(7)], DROP AGGREGATE [drop_aggregate(l)] #p# NAMEALTER AGGREGATE - change the definition of an aggregate function SYNOPSIS ALTER AGGREGATE name ( type ) RENAME TO newname DESCRIPTIONALTER AGGREGATE changes the definition of an aggregate function. The only currently available functionality is to rename the aggregate function. PARAMETERS name The name (optionally schema-qualified) of an existing aggregate function. type The argument data type of the aggregate function, or * if the function accepts any data type. newname The new name of the aggregate function. EXAMPLESTo rename the aggregate function myavg for type integer to my_average: ALTER AGGREGATE myavg(integer) RENAME TO my_average; COMPATIBILITYThere is no ALTER AGGREGATE statement in the SQL standard. SEE ALSOCREATE AGGREGATE [create_aggregate(7)], DROP AGGREGATE [drop_aggregate(l)] |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |